#暂时不使用

from .config import *

def instr_crateTable():
    sql = """
    CREATE TABLE userinfo (
    id INT auto_increment PRIMARY KEY ,
    name CHAR(10) NOT NULL UNIQUE,
    age TINYINT NOT NULL
    )ENGINE=innodb DEFAULT CHARSET=utf8;  
    """
    return sql

def instr_insertValue():

    sql = 'insert into userinfo(name,age) values(\'jax\',\'20\');'
    return sql

def instr_getAllTableName():
    sql = """
    select table_name from information_schema.tables where table_schema='%s'
    """%databaseName

    return sql